
clear
set memory 500m

******** Burkina Faso ***********
clear
use "C:\Users\Nick\Documents\Harvard\Courses\Gov 2001\Replication Paper\DHS Original Files\Burkina Faso\BFAR41FL.dta"

gen country = 1
gen hv001 = hivclust 
gen hv002 = hivnumb 
gen hv003 = hivline
sort country hv001 hv002 hv003

save "C:\Users\Nick\Documents\Harvard\Courses\Gov 2001\Replication Paper\Data files\Country Files\BF_HIV.dta", replace

clear
use "C:\Users\Nick\Documents\Harvard\Courses\Gov 2001\Replication Paper\DHS Original Files\Burkina Faso\BFIR43FL.dta"

gen country = 1
gen hv001 = v001
gen hv002 = v002
gen hv003 = v003
sort country hv001 hv002 hv003

save "C:\Users\Nick\Documents\Harvard\Courses\Gov 2001\Replication Paper\Data files\Country Files\BF_IND.dta", replace

clear
use "C:\Users\Nick\Documents\Harvard\Courses\Gov 2001\Replication Paper\DHS Original Files\Burkina Faso\BFPR44FL.dta"

gen country = 1
sort country hv001 hv002 hv003

save "C:\Users\Nick\Documents\Harvard\Courses\Gov 2001\Replication Paper\Data files\Country Files\BF_HH.dta", replace


******** Cameroon ***********
clear
use "C:\Users\Nick\Documents\Harvard\Courses\Gov 2001\Replication Paper\DHS Original Files\Cameroon\CMAR42FL.dta"

gen country = 2
gen hv001 = hivclust 
gen hv002 = hivnumb 
gen hv003 = hivline
sort country hv001 hv002 hv003

save "C:\Users\Nick\Documents\Harvard\Courses\Gov 2001\Replication Paper\Data files\Country Files\CM_HIV.dta", replace

clear
use "C:\Users\Nick\Documents\Harvard\Courses\Gov 2001\Replication Paper\DHS Original Files\Cameroon\CMIR44FL.dta"

gen country = 2
gen hv001 = v001
gen hv002 = v002
gen hv003 = v003
sort country hv001 hv002 hv003

save "C:\Users\Nick\Documents\Harvard\Courses\Gov 2001\Replication Paper\Data files\Country Files\CM_IND.dta", replace

clear
use "C:\Users\Nick\Documents\Harvard\Courses\Gov 2001\Replication Paper\DHS Original Files\Cameroon\CMPR45FL.dta"

gen country = 2
sort country hv001 hv002 hv003

save "C:\Users\Nick\Documents\Harvard\Courses\Gov 2001\Replication Paper\Data files\Country Files\CM_HH.dta", replace


******** Ghana ***********
clear
use "C:\Users\Nick\Documents\Harvard\Courses\Gov 2001\Replication Paper\DHS Original Files\Ghana\GHAR4AFL.dta"

gen country = 3
gen hv001 = hivclust 
gen hv002 = hivnumb 
gen hv003 = hivline
sort country hv001 hv002 hv003

save "C:\Users\Nick\Documents\Harvard\Courses\Gov 2001\Replication Paper\Data files\Country Files\GH_HIV.dta", replace

clear
use "C:\Users\Nick\Documents\Harvard\Courses\Gov 2001\Replication Paper\DHS Original Files\Ghana\GHIR4AFL.dta"

gen country = 3
gen hv001 = v001
gen hv002 = v002
gen hv003 = v003
sort country hv001 hv002 hv003

save "C:\Users\Nick\Documents\Harvard\Courses\Gov 2001\Replication Paper\Data files\Country Files\GH_IND.dta", replace

clear
use "C:\Users\Nick\Documents\Harvard\Courses\Gov 2001\Replication Paper\DHS Original Files\Ghana\GHPR4BFL.dta"

gen country = 3
sort country hv001 hv002 hv003

save "C:\Users\Nick\Documents\Harvard\Courses\Gov 2001\Replication Paper\Data files\Country Files\GH_HH.dta", replace


******** Kenya ***********
clear
use "C:\Users\Nick\Documents\Harvard\Courses\Gov 2001\Replication Paper\DHS Original Files\Kenya\KEAR42FL.dta"

gen country = 4
gen hv001 = hivclust 
gen hv002 = hivnumb 
gen hv003 = hivline
sort country hv001 hv002 hv003

save "C:\Users\Nick\Documents\Harvard\Courses\Gov 2001\Replication Paper\Data files\Country Files\KE_HIV.dta", replace

clear
use "C:\Users\Nick\Documents\Harvard\Courses\Gov 2001\Replication Paper\DHS Original Files\Kenya\KEIR41FL.dta"

gen country = 4
gen hv001 = v001
gen hv002 = v002
gen hv003 = v003
sort country hv001 hv002 hv003

save "C:\Users\Nick\Documents\Harvard\Courses\Gov 2001\Replication Paper\Data files\Country Files\KE_IND.dta", replace

clear
use "C:\Users\Nick\Documents\Harvard\Courses\Gov 2001\Replication Paper\DHS Original Files\Kenya\KEPR42FL.dta"

gen country = 4
sort country hv001 hv002 hv003

save "C:\Users\Nick\Documents\Harvard\Courses\Gov 2001\Replication Paper\Data files\Country Files\KE_HH.dta", replace


******** Tanzania ***********
clear
use "C:\Users\Nick\Documents\Harvard\Courses\Gov 2001\Replication Paper\DHS Original Files\Tanzania\TZAR4AFL.dta"

gen country = 5
gen hv001 = hivclust 
gen hv002 = hivnumb 
gen hv003 = hivline
sort country hv001 hv002 hv003

save "C:\Users\Nick\Documents\Harvard\Courses\Gov 2001\Replication Paper\Data files\Country Files\TZ_HIV.dta", replace

clear
use "C:\Users\Nick\Documents\Harvard\Courses\Gov 2001\Replication Paper\DHS Original Files\Tanzania\TZIR4AFL.dta"

gen country = 5
gen hv001 = v001
gen hv002 = v002
gen hv003 = v003
sort country hv001 hv002 hv003

save "C:\Users\Nick\Documents\Harvard\Courses\Gov 2001\Replication Paper\Data files\Country Files\TZ_IND.dta", replace

clear
use "C:\Users\Nick\Documents\Harvard\Courses\Gov 2001\Replication Paper\DHS Original Files\Tanzania\TZPR4AFL.dta"

gen country = 5
sort country hv001 hv002 hv003

save "C:\Users\Nick\Documents\Harvard\Courses\Gov 2001\Replication Paper\Data files\Country Files\TZ_HH.dta", replace

